home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 2307 < prev    next >
Unknown  |  1998-01-30  |  299 b 
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file data default
100% disktype Blank disk/medium default (weak)


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 52 45 53 |CHILD IN|SERT RES|
|00000010| 54 52 49 43 54 00 20 20 | 20 57 48 45 4e 20 28 28 |TRICT.  | WHEN ((|
|00000020| 28 73 65 6c 65 63 74 20 | 63 6f 75 6e 74 28 2a 29 |(select |count(*)|
|00000030| 20 66 72 6f 6d 20 25 50 | 61 72 65 6e 74 20 77 68 | from %P|arent wh|
|00000040| 65 72 65 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 4e |ere %Joi|nFKPK(%N|
|00000050| 65 77 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ew,%Pare|nt," = "|
|00000060| 2c 22 20 61 6e 64 22 29 | 29 20 3d 20 30 29 0d 0a |," and")|) = 0)..|
|00000070| 20 20 20 20 20 25 49 66 | 20 28 25 4e 6f 74 6e 75 |     %If| (%Notnu|
|00000080| 6c 6c 46 4b 28 25 4e 65 | 77 2c 22 20 69 73 20 6e |llFK(%Ne|w," is n|
|00000090| 6f 74 20 6e 75 6c 6c 22 | 29 29 20 7b 20 41 4e 44 |ot null"|)) { AND|
|000000a0| 20 25 4e 6f 74 6e 75 6c | 6c 46 4b 28 25 4e 65 77 | %Notnul|lFK(%New|
|000000b0| 2c 22 20 69 73 20 6e 6f | 74 20 6e 75 6c 6c 22 2c |," is no|t null",|
|000000c0| 2c 22 20 61 6e 64 22 29 | 20 7d 29 0d 0a 20 20 20 |," and")| })..   |
|000000d0| 20 20 20 20 53 49 47 4e | 41 4c 20 53 51 4c 53 54 |    SIGN|AL SQLST|
|000000e0| 41 54 45 20 27 34 32 39 | 38 37 27 20 28 27 43 61 |ATE '429|87' ('Ca|
|000000f0| 6e 6e 6f 74 20 49 4e 53 | 45 52 54 20 22 25 43 68 |nnot INS|ERT "%Ch|
|00000100| 69 6c 64 22 20 62 65 63 | 61 75 73 65 20 22 25 50 |ild" bec|ause "%P|
|00000110| 61 72 65 6e 74 22 20 64 | 6f 65 73 20 6e 6f 74 20 |arent" d|oes not |
|00000120| 65 78 69 73 74 2e 27 29 | 00 18 27                |exist.')|..'     |
+--------+-------------------------+-------------------------+--------+--------+